﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ShuiPingHengCX.aspx.cs" Inherits="Web.Pages.YongShui.ShuiPingHGL.ShuiPingHengCX" Theme="Default" %>

<%@ Register Assembly="DevExpress.Web.v15.2, Version=15.2.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" Namespace="DevExpress.Web" TagPrefix="dx" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title></title>
    <script src="../../../../JS/AddEditCancel.js"></script>
    <script type="text/javascript">
    </script>
</head>
<body>
    <form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
        <div class="tabletitle1" align="center">
            水平衡查询
        </div>
        <asp:UpdatePanel ID="updatePanel1" runat="server">
            <ContentTemplate>
                <div class="top" style="width: 100%; margin: auto;">
                    <fieldset style="border: 1px solid  cornflowerblue; width: 97%; margin: auto;">
                        <legend style="font-weight: bold">查询条件</legend>
                        <table>
                            <tr>
                                <td align="right" style="width: 10%">用户号：
                                </td>
                                <td style="width: 12%">
                                    <dx:ASPxTextBox ID="contxtYongHuH" ClientInstanceName="txtconYM" runat="server" Width="100%"></dx:ASPxTextBox>
                                </td>
                                <td align="right" style="width: 10%">用户名：
                                </td>
                                <td>
                                    <dx:ASPxTextBox ID="contxtYongHuM" ClientInstanceName="txtconYM" runat="server" Width="100%"></dx:ASPxTextBox>
                                </td>
                                <td align="right" style="width: 10%">地址：
                                </td>
                                <td>
                                    <dx:ASPxTextBox ID="contxtYongHuDiZhi" ClientInstanceName="txtconYM" runat="server" Width="100%"></dx:ASPxTextBox>
                                </td>
                            </tr>
                            <tr>
                                <td align="right">状态：
                                </td>
                                <td>
                                    <dx:ASPxComboBox runat="server" ID="concmbzhuangtai" Width="100%">
                                     <Items>
                                      <dx:ListEditItem Text="已过期" Value="-2" />
                                      <dx:ListEditItem Text="未做过水平衡" Value="-1"  />
                                      <dx:ListEditItem Text="已做过水平衡" Value="0" Selected="true" />
                                      </Items>
                                    </dx:ASPxComboBox>
                                </td>

                                <td align="right">年：
                                </td>
                                <td style="width: 10%">
                                    <table>
                                        <tr>
                                            <td>
                                                <dx:ASPxComboBox runat="server" ID="concmbY" Width="55px">
                                                    
                                                </dx:ASPxComboBox>
                                            </td>
                                            <td>月:</td>
                                            <td>
                                                <dx:ASPxComboBox runat="server" ID="concmbM" Width="55px">
                                                    <Items>
                                                        <dx:ListEditItem Text="" Value="" Selected="true" />
                                                        <dx:ListEditItem Text="1" Value="1" />
                                                        <dx:ListEditItem Text="2" Value="2" />
                                                        <dx:ListEditItem Text="3" Value="3" />
                                                        <dx:ListEditItem Text="4" Value="4" />
                                                        <dx:ListEditItem Text="5" Value="5" />
                                                        <dx:ListEditItem Text="6" Value="6" />
                                                        <dx:ListEditItem Text="7" Value="7" />
                                                        <dx:ListEditItem Text="8" Value="8" />
                                                        <dx:ListEditItem Text="9" Value="9" />
                                                        <dx:ListEditItem Text="10" Value="10" />
                                                        <dx:ListEditItem Text="11" Value="11" />
                                                        <dx:ListEditItem Text="12" Value="12" />
                                                    </Items>
                                                </dx:ASPxComboBox>
                                            </td>
                                        </tr>
                                    </table>
                                </td>
                                <td align="right" style="width: 16%">年水量范围：
                                </td>
                                <td>
                                    <table>
                                        <tr>
                                            <td>
                                                <dx:ASPxComboBox runat="server" ID="concmbNianShuiLiangRange" Width="60px">
                                                    <Items>
                                                        <dx:ListEditItem Text="" Value="" />
                                                        <dx:ListEditItem Text="=" Value="=" Selected="true" />
                                                         <dx:ListEditItem Text=">" Value=">" />
                                                         <dx:ListEditItem Text="<" Value="<" />
                                                    </Items>
                                                </dx:ASPxComboBox>
                                            </td>
                                            <td>
                                                <dx:ASPxTextBox ID="contxtShuiLiangFanWei" ClientInstanceName="txtconYM" Text="6000" runat="server" Width="60px">
                                                    <ClientSideEvents KeyUp="function(s,e){inputNum(s);}" />
                                                </dx:ASPxTextBox>
                                            </td>
                                            <td align="right" >
                                                <dx:ASPxLoadingPanel ID="LoadPanel" ClientInstanceName="LoadPanel" runat="server" Text="正在查询..."></dx:ASPxLoadingPanel>
                                                <dx:ASPxButton ID="btnSearch" runat="server" Text="查询" OnClick="btnSearch_Click">
                                                    <ClientSideEvents Click="function(s, e) {  
                                                                        LoadPanel.Show();  
                                                                }" />  
                                                </dx:ASPxButton>
                                            </td>
                                        </tr>
                                    </table>
                                </td>
                            </tr>

                        </table>

                    </fieldset>
                </div>
                <div style="height: 3px"></div>

                <fieldset style="border: 1px solid  cornflowerblue; width: 97%; margin: auto;">
                    <legend style="font-weight: bold">查询结果</legend>
                    <dx:ASPxGridView ID="gvShuiPingHengCX" runat="server" AutoGenerateColumns="False" KeyFieldName="ID" Theme="Aqua1" Width="100%">
                        <Columns>
                            <dx:GridViewDataTextColumn FieldName="NO" Caption="序号" Width="40px">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="S_YONGHUH" Caption="用户号" Width="70px">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="S_YONGHUM" Caption="用户名" Width="120px">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="S_DIZHI" Caption="地址" Width="120px">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="I_ZONGGAIXMS" Caption="总改项目数" Width="100px">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="I_YIWANCHENGXMS" Caption="已完成项目数" Width="90px">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="N_ZONGTOUZIJE" Caption="总投资金额(万元)" Width="120px">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="N_JIESHUIL" Caption="节水量（m³/d）" Width="120px">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="N_DULOUL" Caption="堵漏量（m³/d）" Width="120px">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="N_DULOUXM" Caption="堵漏项目数" Width="120px">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="N_DULOUTZJE" Caption="堵漏投资金额(万元)" Width="130px">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="N_GUANJIN" Caption="管径(mm)" Width="120px">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="N_XINSHUIL" Caption="新水量（m³/d）" Width="120px">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="D_BEIANRQ" Caption="备案日期" Width="120px" PropertiesTextEdit-DisplayFormatString="yyyy-MM-dd">
                            </dx:GridViewDataTextColumn>
                        </Columns>
                        <Settings VerticalScrollableHeight="320" VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" />

                    </dx:ASPxGridView>

                </fieldset>
                <div style="height: 3px"></div>

                <div>
                    <span style="float: left; margin-top: 2px">总水平衡户数:</span>
                    <span style="float: left">
                        <dx:ASPxTextBox ID="txtShuiPingHengHuShu" ClientInstanceName="txtconYM" runat="server" Width="80px" Enabled="false"></dx:ASPxTextBox>
                    </span>
                </div>

            </ContentTemplate>
        </asp:UpdatePanel>
    </form>
</body>
</html>


